﻿CREATE PROCEDURE [dbo].[authors_get_by_letter]
   @letter nvarchar(10)
AS
    SELECT Authors.AuthorId, Authors.FirstName, Authors.LastName, Authors.MiddleName
    FROM Authors
    WHERE Authors.LastName LIKE @letter + '%'

RETURN 0
